Installation

1)     To install the Oracle 19c client code, click the link below which will bring you to the zip file: 

2) Oracle 19c 64-bit Client

Oracle 19c 32-bit Client

3)  Right-click on the downloaded zip file and choose Properties. Check the “Unblock” box, Extract the zip file, and Execute the Setup.exe program. Be sure to run Setup.exe as administrator. Follow the process below.

Right-click on the downloaded zip file and choose Properties. Check the “Unblock” box.

Be sure to run Setup.exe as administrator

Select Runtime and then click Next button

Click Next

Change Oracle Base to C:\Oracle. Click Next

Wait for verification to complete

Click Install

The installation will now start as shown above.

If presented, Click Allow Access at Windows Security alert. This window may pop under, or onto another screen.

When installation is complete click Close.

Configuration:

Oracle Directory Naming method for Database Connections

ETS requires Oracle Directory Naming for connection to Oracle databases.   ETS manages many databases on multiple servers which are high-availability RAC clusters.  High availability requires dynamic database location information.  Oracle’s Directory Naming method allows ETS to provide this dynamic database location information.  When ETS adds, removes, or moves a database the directory will provide dynamic information to users and applications for this location change.  Below is a description of how to configure your desktop to use Oracle directory naming; a requirement of all ETS databases that are version10g or above.

1. Login into the ETS VPN you normally login to when accessing ETS supported applications such as BANNER Finance/HR (BPRD) and BANNER Student (PROD).

2. Enter \\ecglib\public$ into the Windows Search box.

4. Copy the LDAP.ORA file and the SQLNET.ORA file to your local desktop into Oracle network\admin folder:

Example: C:\Oracle\product\19.0.0\client_1\network\admin

Note:  your local folder’s full path may be different than above, you just need to find where the network/admin subdirectory is and place copies of the two aforementioned files in the ADMIN subdirectory. 

To remove the Oracle client, run this command from an elevated (Run as administrator) Command prompt. C:\[Oracle home]\product\19.0.0\client_1\deinstall\deinstall.bat

Example: C:\Oracle\product\19.0.0\client_1\deinstall

Type Y when prompted

Complete